/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * bzr_maVerwaltung.java
 *
 * Created on 17.03.2011, 09:15:05
 */

package bzr_mitarbeiterverwaltung;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.ResultSet;
import com.mysql.jdbc.Statement;
import java.util.Date;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.DefaultListModel;
import javax.swing.SpinnerDateModel;
import javax.swing.SpinnerModel;

/**
 *
 * @author mreisz
 */
public class bzr_maVerwaltung extends javax.swing.JFrame {


    /** Creates new form bzr_maVerwaltung */
    public bzr_maVerwaltung() {
        initComponents();


        jComboBoxFreieMA.setVisible(false);
        jLabelBank.setVisible(false);
        jLabelGebDat.setVisible(false);
        jLabelAusbildung.setVisible(false);
        jLabelBez.setVisible(false);
        jLabelEMail.setVisible(false);
        jLabelID.setVisible(false);
        jLabelMAID.setVisible(false);
        jLabelNachname.setVisible(false);
        jLabelPhone.setVisible(false);
        jLabelSVNR.setVisible(false);
        jLabelStaatsbürgerschaft.setVisible(false);
        jLabelVorname.setVisible(false);
        jTextFieldEMail.setVisible(false);
        jTextFieldNachname.setVisible(false);
        jTextFieldPhone.setVisible(false);
        jTextFieldVorname.setVisible(false);
        jButtonNew.setVisible(false);
        jLabelKonfekt.setVisible(false);
        jComboBoxFührerschein.setVisible(false);
        jLabelFührerschein.setVisible(false);
        jSpinnerGebDat.setVisible(false);
        jTextFieldSVNR.setVisible(false);
        jTextFieldStaatsbürgerschaft.setVisible(false);
        jTextFieldAusbildung.setVisible(false);
        jTextFieldBank.setVisible(false);
        jTextFieldKonfektgr.setVisible(false);
        jTextFieldSVNR.setVisible(false);

        try {
            con  = (Connection) DriverManager.getConnection("jdbc:mysql://mysql.bezirksrundschau.com:3306/brdbm_1", "brdbm", "br2011!db");
            Statement st = (Statement) con.createStatement();
            ResultSet rs = (ResultSet) st.executeQuery("SELECT * FROM Freie_Mitarbeiter");

            while (rs.next()) {
                dlm.addElement(rs.getString("Vorname") + " " + rs.getString("Nachname") + ", " + rs.getString("MAArt"));

            }
            jListMitarbeiter.setModel(dlm);
            con.close();
        } catch (SQLException ex) {
            Logger.getLogger(bzr_maVerwaltung.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
    private void initComponents() {

        buttonFreieMA = new javax.swing.JButton();
        buttonLieferanten = new javax.swing.JButton();
        jComboBoxFreieMA = new javax.swing.JComboBox();
        jLabelMAID = new javax.swing.JLabel();
        jLabelID = new javax.swing.JLabel();
        jLabelVorname = new javax.swing.JLabel();
        jLabelNachname = new javax.swing.JLabel();
        jLabelPhone = new javax.swing.JLabel();
        jLabelEMail = new javax.swing.JLabel();
        jLabelBez = new javax.swing.JLabel();
        jLabelGebDat = new javax.swing.JLabel();
        jLabelAusbildung = new javax.swing.JLabel();
        jLabelSVNR = new javax.swing.JLabel();
        jLabelStaatsbürgerschaft = new javax.swing.JLabel();
        jLabelBank = new javax.swing.JLabel();
        jTextFieldVorname = new javax.swing.JTextField();
        jTextFieldNachname = new javax.swing.JTextField();
        jTextFieldEMail = new javax.swing.JTextField();
        jTextFieldPhone = new javax.swing.JTextField();
        jButtonNew = new javax.swing.JButton();
        jScrollPane1 = new javax.swing.JScrollPane();
        jListMitarbeiter = new javax.swing.JList();
        jTextFieldBezirk = new javax.swing.JTextField();
        jTextFieldAusbildung = new javax.swing.JTextField();
        jTextFieldSVNR = new javax.swing.JTextField();
        jTextFieldStaatsbürgerschaft = new javax.swing.JTextField();
        jTextFieldBank = new javax.swing.JTextField();
        jLabelKonfekt = new javax.swing.JLabel();
        jTextFieldKonfektgr = new javax.swing.JTextField();
        jLabelFührerschein = new javax.swing.JLabel();
        jComboBoxFührerschein = new javax.swing.JComboBox();
        jSpinnerGebDat = new javax.swing.JSpinner();
        jMenuBar1 = new javax.swing.JMenuBar();
        jMenu1 = new javax.swing.JMenu();
        jMenu2 = new javax.swing.JMenu();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

        buttonFreieMA.setText("Freie Mitarbeiter");
        buttonFreieMA.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                buttonFreieMAActionPerformed(evt);
            }
        });

        buttonLieferanten.setText("Lieferanten");

        jComboBoxFreieMA.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Promo", "Aufbauer" }));
        jComboBoxFreieMA.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jComboBoxFreieMAActionPerformed(evt);
            }
        });

        jLabelMAID.setText("MitarbeiterID:");

        jLabelID.setText("ID_Label");

        jLabelVorname.setText("Vorname:");

        jLabelNachname.setText("Nachname:");

        jLabelPhone.setText("Telefonnummer:");

        jLabelEMail.setText("E-Mail:");

        jLabelBez.setText("Bezirk:");

        jLabelGebDat.setText("Alter:");

        jLabelAusbildung.setText("Ausbildung:");

        jLabelSVNR.setText("SV_NR.:");

        jLabelStaatsbürgerschaft.setText("Staatsbürgerschaft:");

        jLabelBank.setText("BANK??");

        jButtonNew.setText("Neu Anlegen");
        jButtonNew.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButtonNewActionPerformed(evt);
            }
        });

        jListMitarbeiter.setModel(new javax.swing.AbstractListModel() {
            String[] strings = { "Item 1", "Item 2", "Item 3", "Item 4", "Item 5" };
            public int getSize() { return strings.length; }
            public Object getElementAt(int i) { return strings[i]; }
        });
        jScrollPane1.setViewportView(jListMitarbeiter);

        jLabelKonfekt.setText("Konfektionsgr.:");

        jLabelFührerschein.setText("Führerschein");

        jComboBoxFührerschein.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "JA", "NEIN" }));

        jSpinnerGebDat.setModel(new javax.swing.SpinnerDateModel(new java.util.Date(1301559854353L), new java.util.Date(1301559854353L), null, java.util.Calendar.AM_PM));

        jMenu1.setText("Datei");
        jMenuBar1.add(jMenu1);

        jMenu2.setText("?");
        jMenuBar1.add(jMenu2);

        setJMenuBar(jMenuBar1);

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(layout.createSequentialGroup()
                        .addComponent(jButtonNew, javax.swing.GroupLayout.PREFERRED_SIZE, 121, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addContainerGap(555, Short.MAX_VALUE))
                    .addGroup(layout.createSequentialGroup()
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(jLabelBez)
                            .addGroup(layout.createSequentialGroup()
                                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
                                    .addComponent(jComboBoxFreieMA, javax.swing.GroupLayout.Alignment.LEADING, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                    .addComponent(buttonFreieMA, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                                .addGap(18, 18, 18)
                                .addComponent(buttonLieferanten))
                            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
                                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addComponent(jLabelPhone)
                                    .addComponent(jLabelMAID)
                                    .addComponent(jLabelVorname)
                                    .addComponent(jLabelNachname)
                                    .addComponent(jLabelEMail))
                                .addGap(18, 18, 18)
                                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addComponent(jTextFieldEMail, javax.swing.GroupLayout.DEFAULT_SIZE, 135, Short.MAX_VALUE)
                                    .addComponent(jLabelID)
                                    .addComponent(jTextFieldPhone, javax.swing.GroupLayout.DEFAULT_SIZE, 135, Short.MAX_VALUE)
                                    .addComponent(jTextFieldNachname, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, 135, Short.MAX_VALUE)
                                    .addComponent(jTextFieldVorname, javax.swing.GroupLayout.DEFAULT_SIZE, 135, Short.MAX_VALUE)
                                    .addComponent(jTextFieldBezirk, javax.swing.GroupLayout.DEFAULT_SIZE, 135, Short.MAX_VALUE)
                                    .addComponent(jTextFieldAusbildung, javax.swing.GroupLayout.DEFAULT_SIZE, 135, Short.MAX_VALUE)
                                    .addComponent(jTextFieldSVNR, javax.swing.GroupLayout.DEFAULT_SIZE, 135, Short.MAX_VALUE)
                                    .addComponent(jTextFieldStaatsbürgerschaft, javax.swing.GroupLayout.DEFAULT_SIZE, 135, Short.MAX_VALUE)
                                    .addComponent(jTextFieldBank, javax.swing.GroupLayout.DEFAULT_SIZE, 135, Short.MAX_VALUE)
                                    .addComponent(jTextFieldKonfektgr, javax.swing.GroupLayout.DEFAULT_SIZE, 135, Short.MAX_VALUE)
                                    .addComponent(jComboBoxFührerschein, 0, 135, Short.MAX_VALUE)
                                    .addComponent(jSpinnerGebDat))
                                .addGap(97, 97, 97))
                            .addGroup(layout.createSequentialGroup()
                                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addComponent(jLabelBank)
                                    .addComponent(jLabelStaatsbürgerschaft)
                                    .addComponent(jLabelSVNR)
                                    .addComponent(jLabelAusbildung)
                                    .addComponent(jLabelGebDat))
                                .addGap(223, 223, 223))
                            .addGroup(layout.createSequentialGroup()
                                .addComponent(jLabelKonfekt)
                                .addGap(246, 246, 246))
                            .addGroup(layout.createSequentialGroup()
                                .addComponent(jLabelFührerschein)
                                .addGap(258, 258, 258)))
                        .addGap(100, 100, 100)
                        .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 238, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(18, 18, 18))))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 401, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addGroup(layout.createSequentialGroup()
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(buttonFreieMA)
                            .addComponent(buttonLieferanten))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addComponent(jComboBoxFreieMA, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabelMAID)
                            .addComponent(jLabelID))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabelVorname)
                            .addComponent(jTextFieldVorname, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabelNachname)
                            .addComponent(jTextFieldNachname, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabelPhone)
                            .addComponent(jTextFieldPhone, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabelEMail)
                            .addComponent(jTextFieldEMail, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabelBez)
                            .addComponent(jTextFieldBezirk, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabelGebDat)
                            .addComponent(jSpinnerGebDat, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabelAusbildung)
                            .addComponent(jTextFieldAusbildung, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabelSVNR)
                            .addComponent(jTextFieldSVNR, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabelStaatsbürgerschaft)
                            .addComponent(jTextFieldStaatsbürgerschaft, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabelBank)
                            .addComponent(jTextFieldBank, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabelKonfekt)
                            .addComponent(jTextFieldKonfektgr, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabelFührerschein)
                            .addComponent(jComboBoxFührerschein, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addGap(40, 40, 40)
                        .addComponent(jButtonNew)))
                .addContainerGap(44, Short.MAX_VALUE))
        );

        pack();
    }// </editor-fold>//GEN-END:initComponents

    private void buttonFreieMAActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_buttonFreieMAActionPerformed
        jComboBoxFreieMA.setVisible(true);
        jLabelBank.setVisible(true);
        jLabelGebDat.setVisible(true);
        jLabelAusbildung.setVisible(true);
        jLabelBez.setVisible(true);
        jLabelEMail.setVisible(true);
        jLabelID.setVisible(true);
        jLabelMAID.setVisible(true);
        jLabelNachname.setVisible(true);
        jLabelPhone.setVisible(true);
        jLabelSVNR.setVisible(true);
        jLabelStaatsbürgerschaft.setVisible(true);
        jLabelVorname.setVisible(true);
        jTextFieldEMail.setVisible(true);
        jTextFieldNachname.setVisible(true);
        jTextFieldPhone.setVisible(true);
        jTextFieldVorname.setVisible(true);
        jButtonNew.setVisible(true);
        jLabelKonfekt.setVisible(true);
        jComboBoxFührerschein.setVisible(true);
        jLabelFührerschein.setVisible(true);
        jSpinnerGebDat.setVisible(true);
        jTextFieldSVNR.setVisible(true);
        jTextFieldStaatsbürgerschaft.setVisible(true);
        jTextFieldAusbildung.setVisible(true);
        jTextFieldBank.setVisible(true);
        jTextFieldKonfektgr.setVisible(true);
        jTextFieldSVNR.setVisible(true);

    }//GEN-LAST:event_buttonFreieMAActionPerformed

    private void jComboBoxFreieMAActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jComboBoxFreieMAActionPerformed

       
    }//GEN-LAST:event_jComboBoxFreieMAActionPerformed

    private void jButtonNewActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButtonNewActionPerformed
        Date d = (Date) jSpinnerGebDat.getValue();
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        String date = sdf.format(d);

        try {
            con = (Connection) DriverManager.getConnection("jdbc:mysql://mysql.bezirksrundschau.com:3306/brdbm_1", "brdbm", "br2011!db");
            Statement st = (Statement) con.createStatement();
            int x = st.executeUpdate("INSERT INTO Freie_Mitarbeiter(`Vorname`,`Nachname`,`Telefonnummer`,`EMail`,`Bezirk`,`GebDatum`,`Ausbildung`,`Konfektionsgroeße`,`Fuehrerschein`,`SVNr`,`Staatsbuergerschaft`,`Bankverbindung`,`MAArt`) VALUES "
                    + "('"+jTextFieldVorname.getText()+"','"+jTextFieldNachname.getText()+ "'," +
                    jTextFieldPhone.getText()+",'"+jTextFieldEMail.getText()+"','"+jTextFieldBezirk.getText()+"','"+date+
                    "','"+jTextFieldAusbildung.getText()+"',"+jTextFieldKonfektgr.getText()+",'"+jComboBoxFührerschein.getSelectedItem().toString()+
                    "',"+jTextFieldSVNR.getText()+",'"+jTextFieldStaatsbürgerschaft.getText()+"',"+jTextFieldBank.getText()+",'"+
                    jComboBoxFreieMA.getSelectedItem().toString()+ "');");

            dlm.clear();
            st = (Statement) con.createStatement();
            ResultSet rs = (ResultSet) st.executeQuery("SELECT * FROM Freie_Mitarbeiter");
            while (rs.next()) {
                dlm.addElement(rs.getString("Vorname") + " " + rs.getString("Nachname") + ", " + rs.getString("MAArt"));
            }
            jListMitarbeiter.setModel(dlm);
            con.close();
        } catch (SQLException ex) {
            Logger.getLogger(bzr_maVerwaltung.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_jButtonNewActionPerformed

    /**
    * @param args the command line arguments
    */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new bzr_maVerwaltung().setVisible(true);
            }
        });
    }

    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.JButton buttonFreieMA;
    private javax.swing.JButton buttonLieferanten;
    private javax.swing.JButton jButtonNew;
    private javax.swing.JComboBox jComboBoxFreieMA;
    private javax.swing.JComboBox jComboBoxFührerschein;
    private javax.swing.JLabel jLabelAusbildung;
    private javax.swing.JLabel jLabelBank;
    private javax.swing.JLabel jLabelBez;
    private javax.swing.JLabel jLabelEMail;
    private javax.swing.JLabel jLabelFührerschein;
    private javax.swing.JLabel jLabelGebDat;
    private javax.swing.JLabel jLabelID;
    private javax.swing.JLabel jLabelKonfekt;
    private javax.swing.JLabel jLabelMAID;
    private javax.swing.JLabel jLabelNachname;
    private javax.swing.JLabel jLabelPhone;
    private javax.swing.JLabel jLabelSVNR;
    private javax.swing.JLabel jLabelStaatsbürgerschaft;
    private javax.swing.JLabel jLabelVorname;
    private javax.swing.JList jListMitarbeiter;
    private javax.swing.JMenu jMenu1;
    private javax.swing.JMenu jMenu2;
    private javax.swing.JMenuBar jMenuBar1;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JSpinner jSpinnerGebDat;
    private javax.swing.JTextField jTextFieldAusbildung;
    private javax.swing.JTextField jTextFieldBank;
    private javax.swing.JTextField jTextFieldBezirk;
    private javax.swing.JTextField jTextFieldEMail;
    private javax.swing.JTextField jTextFieldKonfektgr;
    private javax.swing.JTextField jTextFieldNachname;
    private javax.swing.JTextField jTextFieldPhone;
    private javax.swing.JTextField jTextFieldSVNR;
    private javax.swing.JTextField jTextFieldStaatsbürgerschaft;
    private javax.swing.JTextField jTextFieldVorname;
    // End of variables declaration//GEN-END:variables
    private Connection con;
    private DefaultListModel dlm = new DefaultListModel();
}
